REM Creating Tables COPY_EMP and SALES_REP that is required for the code examples in lesson 8

CREATE TABLE SALES_REPS (
 ID               NUMBER(6) NOT NULL,
 NAME             VARCHAR2(20),
 SALARY           NUMBER(8,2),
 COMMISSION_PCT   NUMBER(2,2)
)
/

CREATE TABLE copy_emp  AS (
  SELECT * 
  FROM employees 
  WHERE 1 = 2)
/
